All Questions
Tagged with postgresqlubuntu
25 questions
1vote
0answers
163views
Ubuntu service - pq: password authentication failed for user "root"
I have an application running on Ubuntu server that's using PostgreSQL. I can run the application's executable (as a non-root user) from the project's directory. I have created a service for this ...
- 111
0votes
0answers
417views
How was my postgres docker container hacked / infected
My VPS have been infected by the kdevtmpfsi malware, twice. That's the problem, because I've taken every possible precaution after being infected for the first time, and I have no idea how I'm being ...
- 1,808
0votes
0answers
46views
Ubuntu - PostegreSQL displays errors in foreign language even after changing all locales to en_US and reinstalling it
I inherited a Ubuntu desktop from another employee and installed PostgreSQL with the help of the official guide. abc@lenovo:~$ sudo apt install postgresql-15 I had not known that I had to setup an ...
1vote
1answer
1kviews
how to download postgres data in csv format through bash script?
I am able to connect to db also getting output but it's not coming in proper format. So how to get the output in csv like format and also want to save that in csv format. psql -d <db> -U <...
- 113
0votes
1answer
206views
How to upgrade Postgresql 11.2 to 11.17 on Ubunutu 14.04
We have a Ubuntu 14.04 server with Postgresql 11.2 installed. We need to upgrade it to 11.17. I have read old versions of Postgresql will move to https://apt-archive.postgresql.org/. So I have updated ...
0votes
1answer
251views
Make Tar from Snapshot of Changing Folder (Btrfs?)
I have BTRFS on my Ubuntu server, and I’m using PostgreSQL as a database. I’d like to make a .tar.gz archive from the current state of the database folder. However, since the database is of course ...
-2votes
2answers
1kviews
Cannot create /proc/sys/vm/drop_caches: Permission denied
I am using python because i try to run some queries from psql in cold state in a for loop.So before the execution of every query my cache must be clear.I imported os and then i did this: if state==&...
0votes
1answer
2kviews
Unable to successfully change Postgresql data_directory and restart Postgres
My goal is to store my postgresql database data on an external ssd hard drive that I have plugged in to a machine running Linux Ubuntu 20.04 LTS ARM x64. I am running into problems when changing the ...
- 131
0votes
0answers
111views
Starting postgresql 10 from mounted drive
I have Ubuntu 18.04 with boot disk of 30 GB(VM_A) and there was mounted drive(4TB) to it from another machine. due to a recent restart the mounted drive was unmounted then i had to mount that drive to ...
0votes
0answers
149views
Cannot use postgresql on Ubuntu terminal, getting errors
psql is successfully installed on my Linux environment (Ubuntu) but when using psql commands I get the following psql: error: could not connect to server: could not connect to server: No such file ...
-1votes
2answers
4kviews
Ubuntu could not open lock file /var/lib/dpkg/lock - open (13: Permission denied)
I'm trying to create a new user form my rails application. I already ran psql -p 5432 -h localhsot -U postgres and created a new user. Then I added the user with sudo adduser user_name and afterwards ...
2votes
2answers
7kviews
root "su - <user>" got permission denied (Ignored)
Got permission denied when switching user from root to postgres. No issue switching from root to ubuntu. root@node-01:~# su - postgres su: Permission denied (Ignored) postgres@node-01:~$ logout root@...
- 171
0votes
2answers
3kviews
Separate systemd script for postgresql instances
I have PostgreSQL-11 installed on Ubuntu 18.04 via apt-get, and based from here, I managed to install 2 instances of postgreSQL on port 5432 and 5433. My Question is, can I have separate start-stop ...
3votes
1answer
1kviews
Unable to start postgres unless I type the command to restart it
Whenever I try to start my project the following error occurs. django.db.utils.OperationalError: could not connect to server: No such file or directory Is the server running locally and ...
9votes
3answers
26kviews
Unable to locate package postgresql-server-dev?
I am trying to install the following packcage postgresql-server-dev-9.5. Using sudo apt-get install postgresql-server-dev-9.5 Now, after I run this command I get this error: Unable to locate ...
- 223
